<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en-us" xml:lang="en-us">
 <head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="DC.Type" content="topic">
  <meta name="DC.Title" content="Anonymizing Data in an Oracle Database">
  <meta name="product" content="">
  <meta name="DC.Relation" scheme="URI" content="helpcenter000108.html">
  <meta name="prodname" content="">
  <meta name="version" content="">
  <meta name="brand" content="30-OceanProtect Appliance 1.5.0-1.6.0 Help Center">
  <meta name="DC.Publisher" content="20241029">
  <meta name="documenttype" content="usermanual">
  <meta name="prodname" content="csbs">
  <meta name="DC.Format" content="XHTML">
  <meta name="DC.Identifier" content="data_masking_000015">
  <meta name="DC.Language" content="en-us">
  <link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
  <title>Anonymizing Data in an Oracle Database</title>
 </head>
 <body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px">
  <a name="data_masking_000015"></a><a name="data_masking_000015"></a>
  <h1 class="topictitle1">Anonymizing Data in an Oracle Database</h1>
  <div>
   <p>This section describes how to use the data anonymization feature to anonymize data in a restored or mounted Oracle database.</p>
   <div class="section">
    <h4 class="sectiontitle">Prerequisites</h4>
    <ul>
     <li>You have obtained the management IP address and name of the database to be anonymized.</li>
     <li>You have obtained the user information (user name and password) of the database tablespace to be anonymized, and the user has the remote access permission.</li>
     <li>You have obtained the service IP address and port number of the database to be anonymized.</li>
     <li>Database listening has been configured. For details about how to configure database listening, see "Configuring Oracle Database Listening Parameters" in the <em></em><em>Data Backup Feature Guide (for Oracle)</em>.</li>
    </ul>
   </div>
   <div class="section">
    <h4 class="sectiontitle">Precautions</h4>
    <ul>
     <li>Do not perform any data anonymization operations on the production database.</li>
     <li>Do not operate the database during sensitive data identification and anonymization.</li>
    </ul>
   </div>
   <div class="section">
    <h4 class="sectiontitle">Identifying Sensitive Data</h4>
    <ol>
     <li><span>In the navigation pane, choose <span class="menucascade"><b><span class="uicontrol">Data Security</span></b> &gt; <b><span class="uicontrol">Data Anonymization</span></b> &gt; <b><span class="uicontrol">Oracle</span></b></span>.</span><p></p>
      <div class="note">
       <img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span>
       <div class="notebody">
        <p>For 1.5.0, choose <span><strong>Explore</strong></span> &gt; <span><strong>Data Anonymization</strong></span> in the navigation pane and click <span><strong>Oracle</strong></span>.</p>
       </div>
      </div> <p></p></li>
     <li><span>On the right <span><strong>Oracle</strong></span> page, search for the database to be anonymized based on its management IP address and name.</span></li>
     <li><span>In the <span><strong>Operation</strong></span> column of the database to be anonymized, choose <span><strong>More</strong></span> &gt; <span><strong>Identify Sensitive Data</strong></span>.</span></li>
     <li><span>In the <span><strong>Identify Sensitive Data</strong></span> dialog box, select a data anonymization policy and click <span><strong>OK</strong></span>.</span><p></p><p>In case a large number of anonymization policies exist, you can enter a policy name to search. Fuzzy search is supported. Click <span><img src="en-us_image_0000001792397164.png"></span> on the right to display anonymization policies in thumbnails or a list.</p> <p>If the existing anonymization policies do not meet your requirements, you can click <strong>Create</strong> to add a new policy. For details about the parameters related to anonymization policies, see <a href="data_masking_000013.html#data_masking_000013__table988710276918">Table 1</a>.</p> <p></p></li>
     <li id="data_masking_000015__li188477531581"><span>In the <span id="data_masking_000015__text1484805312814"><strong>Authenticate</strong></span> window, enter the Oracle database authentication information and click <span id="data_masking_000015__text58481535815"><strong>OK</strong></span>.</span><p></p><p id="data_masking_000015__p168881111597">Enter the authentication information based on the user information (user name and password) of the database tablespace, service IP address, and port number obtained in the prerequisites. The default port number of the Oracle database is <strong id="data_masking_000015__b67048351631">1521</strong>.</p> <p></p></li>
     <li><span>Read the information and click <strong>OK</strong> to start identifying sensitive data.</span><p></p>
      <div class="notice">
       <span class="noticetitle"><img src="public_sys-resources/notice_3.0-en-us.png"> </span>
       <div class="noticebody">
        <p>It may take a long time to complete sensitive data identification. When the database status is <span><strong>Identifying</strong></span>, do not perform any operation on the database.</p>
       </div>
      </div> <p>If <span><strong>Identification Status</strong></span> of the database is displayed as <span><strong>Identified</strong></span>, the identification is successful.</p> <p>If <span><strong>Identification Status</strong></span> of the database is displayed as <span><strong>Identification failed</strong></span>, click the database name. On the displayed page, click the <span><strong>Jobs</strong></span> tab, and then click the <span><strong>Historical Jobs</strong></span> tab. View the failure cause, and rectify the fault based on the handling suggestion.</p> <p></p></li>
    </ol>
   </div>
   <div class="section">
    <h4 class="sectiontitle">Anonymizing Sensitive Data</h4>
    <ol>
     <li><span>In the <span><strong>Operation</strong></span> column of the database whose data is to be anonymized, choose <span><strong>More</strong></span> &gt; <span><strong>Anonymize</strong></span>.</span></li>
     <li><span>In the <span><strong>Anonymize</strong></span> window, click the database tablespace and database table to view the identification result.</span><p></p><p>If <strong>(xxx)</strong> is displayed on the right of a column name in a database table, the corresponding column contains sensitive data. <strong>xxx</strong> indicates the name of an identification rule.</p> <p>You can verify or modify the identification result.</p>
      <ul>
       <li>Verification<p>Verify whether the identification result is correct.</p> <p>Select one to three columns of identification results for a single database table and click <span><strong>Verify</strong></span>. In the dialog box that is displayed, enter the username, password, service IP address, port number, start location, and maximum number of rows of the database, and click <strong>OK</strong>. In the displayed <span><strong>Verification Result</strong></span> window, you can check whether the identification results are correct. If the identification results are incorrect, you can modify them.</p></li>
       <li>Modification<p>If the identification result is regarded as incorrect or does not meet your requirements, you can modify the identification result or the anonymization rule.</p> <p>Click <span><img src="en-us_image_0000001839276217.png"></span> on the right of a column name. In the <span><strong>Modify</strong></span> dialog box, enable or disable <span><strong>Sensitive</strong></span>. After enabling the switch, you also need to set <span><strong>Sensitive Data Name</strong></span> and select a new anonymization rule. Click <span><strong>OK</strong></span> to complete the modification.</p>
        <div class="note">
         <img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span>
         <div class="notebody">
          <p>If the anonymization rule <strong>Partial-Mask</strong> is selected, you also need to enter the start and end positions of sensitive data in this column.</p>
         </div>
        </div></li>
      </ul> <p></p></li>
     <li><span>Click <strong>OK</strong>.</span></li>
     <li><span>In the <span id="data_masking_000015__data_masking_000015_text1484805312814"><strong>Authenticate</strong></span> window, enter the Oracle database authentication information and click <span id="data_masking_000015__data_masking_000015_text58481535815"><strong>OK</strong></span>.</span><p></p><p id="data_masking_000015__data_masking_000015_p168881111597">Enter the authentication information based on the user information (user name and password) of the database tablespace, service IP address, and port number obtained in the prerequisites. The default port number of the Oracle database is <strong id="data_masking_000015__data_masking_000015_b67048351631">1521</strong>.</p> <p></p></li>
     <li><span>Read the message in <span><strong>Danger</strong></span>, select <span><strong>I have read and understand the consequences associated with performing this operation.</strong></span>, and click <strong>OK</strong> to start data anonymization.</span><p></p>
      <div class="caution">
       <span class="cautiontitle"><img src="public_sys-resources/caution_3.0-en-us.png"> </span>
       <div class="cautionbody">
        <p>The anonymized data will be written into the database. Ensure that the database to be anonymized is a non-production database.</p>
        <p>Do not operate the database during data anonymization.</p>
       </div>
      </div> <p>If <span><strong>Anonymization Status</strong></span> of the database is displayed as <span><strong>Anonymized</strong></span>, data anonymization is successful.</p> <p>If <span><strong>Anonymization Status</strong></span> of the database is displayed as <span><strong>Anonymization failed</strong></span>, click the database name. On the displayed page, click the <span><strong>Jobs</strong></span> tab, and then click the <span><strong>Historical Jobs</strong></span> tab. View the failure cause, and rectify the fault based on the handling suggestion.</p> <p></p></li>
    </ol>
   </div>
   <div class="section">
    <h4 class="sectiontitle">Viewing the Anonymization Report</h4>
    <ol>
     <li><span>In the <span><strong>Operation</strong></span> column of the database whose data has been anonymized, choose <span><strong>More</strong></span> &gt; <span><strong>View Anonymization Report</strong></span>.</span><p></p><p>In the <span><strong>Anonymization Report</strong></span> window, view the anonymization result. If <strong>(xxx)</strong> is displayed on the right of a column name in a database table, the corresponding column contains sensitive data. <em>xxx</em> indicates a sensitive data name.</p> <p></p></li>
     <li><span>You can also click <span><strong>Download Report</strong></span> to save the anonymization report.</span><p></p><p>The anonymization report, which is in CSV format, contains the ID, database ID, database name, database tablespace, database table name, column name, identification rule name, and anonymization rule type.</p> <p></p></li>
    </ol>
   </div>
  </div>
  <div>
   <div class="familylinks">
    <div class="parentlink">
     <strong>Parent topic:</strong> <a href="helpcenter000108.html">Data Anonymization</a>
    </div>
   </div>
  </div>
 </body>
</html>